Sales Ledger Formatting - How to insert an item description without cut/paste 25k rows?

**HereToLearn** · 09-17-2013, 09:49 AM

Good morning! I'm new to posting on help forums, please bear with me and feel free to offer suggestions on better methods to posting questions. Here it goes...

I'm working from a sales ledger file whereby I want all invoice data in one row although the Item Number & Item Description are on the first row. Rows 2-10 (for example) are the actual details of the invoice: Invoice #; Date; Customer ID; Customer Name; QTY; etc.

Is there a formula or easier way than copying/pasting the "Item Description" to the first column (J in this case) without any related invoice data?

Any feedback is greatly appreciated and I look forward to hearing back!

**FDibbins** · 09-17-2013, 09:52 AM

hi and welcome to the forum

Do you mean that you have data in rows, and you want to convert that to some in rows and some in columns?

If might be easier to understand and offer suggestions if you could upload a sample workbook, showing what you are working with (no sensitive data), and what your expected outcome would be?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**HereToLearn** · 09-17-2013, 10:09 AM

Attachment 265860

I trust I attached the "Visual Reference - 09172013 Post" file correctly...thank you for helping!

I am not trying to convert data from rows to columns.

In the attached file, please note:

Rows 1-5 are the basic setup on the data to follow. Row 1 is the first set of data provided for invoice details on my report, Row 5 is the additional data that falls between the "Item" info and the "Item Total" at the last point of the details (ie: Row 12). In short, Rows 9-12 is the current structure of the report whereby I would like to find a way to have the "ABC Item Description" pull into cells H21:H22 without copying/pasting all the way down.

Does that help any?