How do I automaticaly transfer data from Columns to lines

[russelldt]

I have a file (file1.xlsm), which has 3 columns: Class, Supplier and Invoice. This is a download from an accounting package. The number in the Class column can appear more than once, if more than one invoice has been issued for that Class..

I have a second file (file2.xlsm) that has one line for each Class and in this line there are 4 cells (columns M,N,O &P) for the involve numbers to appear. So, if there is only 1 invoice for the class, the invoice number will appear in cell M of the Class line, if there are 2 invoices, the second invoice will appear in column N, and so on.

Looking for a solution that will do this.

Many thanks

 

[ranman256]

pivot table
put cursor in a1, click menu: INSERT,
click Pivot table icon (far left)
accept the given selected data
in far right PivotTable fields, drag the fields you want in ROWS, and Columns and Values.

 

[russelldt]

pivot table
put cursor in a1, click menu: INSERT,
click Pivot table icon (far left)
accept the given selected data
in far right PivotTable fields, put the fields you want in ROWS, and Columns and Values.

Thanks Ranman,

I can't use a pivot here, as the file I am using (File2.xlsm) has other data as well, so unfortunately its not as easy as this. I wish it was.

I need something to specifically look at the Class (column C) in File2, and extract the data from File1and place it in the columns.

 

[russelldt]

It is possible for me to add the data from File2, to a new sheet in File1, and this might provide a simpler solution.