Excel 2007: How can I easily change rows of data to populate into columns?
Posted on 2012-03-13
I have one invoice with several lines going down. I have a charge-card bill that has several line items. I've downloaded it and added columns to encode it out to enter to our Financial/Accounting Software. For me to upload it - I need to have all of that data reading on "one line" - i.e. all in columns (not rows).
What is the simplest way for me to do this? - without me getting into any elaborate pivoting process. Or - is pivoting the only way to do it?
I want to auto load it - and - need to have all the data that is now in one column for account number, $ amount, charge-description : to go into the same row, horizontally. Now, the whole file is vertically place with each row having the same invoice number, same vendor name, and then one line item (account to charge, charge-vendor description, $ amount) per row.