Hello, I have attached a sheet for reference. I am looking to transpose my data, perhaps a pivot table can do it, not sure?
Thanks so much in advance!!!
Hello, I have attached a sheet for reference. I am looking to transpose my data, perhaps a pivot table can do it, not sure?
Thanks so much in advance!!!
Hi
You were correct a pivot table will solve your issue. I have attached a rough solution using excel recommended pivot table.
Cheers
Thanks,
See the screenshot I provided. Mine does not have the material or unit in the correct spot.
Attachment 620685Perhaps I did something wrong on the field selections?
Hi
You need to drag the material field and unit field (from Pivot table field window) to rows (material on top and units last) then:-
Right click on each field in the pivot table and in Field Settings set subtotal to None and Layout to tabular
This should align fields as sought.
Cheers
Awesome !!!!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks