Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert Rows data
Hi there,
I have the following sample data: PARTNUMBER QTY RATe PRUN VALID_FROM_VALID_TO ZWR1 0.1095 USD 1 20050512 20050526 XREZ12 0.1095 USD 1 20050527 99991231 is it possible to put this data in the following: 20050512 20050526 20050527 99991231 ZWR1 XREZ12 0.1095 0.1095 USD USD 1 1 So basically make the existing Row heading as Column heading, Please advise if this can be done. Been trying to do with pivot but can't seem to get it to work. Really appreciate any help. Thank YOU, J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data from rows to columns | Excel Discussion (Misc queries) | |||
Get External Data - Insert Rows | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |