Transpose data
thanks mike that was helpful.
"Mike" wrote:
Is there way in Excel I can transpose the data show her in "Original" to
"Required" format [the alignment of data did not copy exactly].
In the Required format the Original column names are changed to code numbers
Original Format
Emp No Date Charge Rent Service Furniture
005083 14/07/2006 88 71 0 17
000086 16/07/2006 107 107 0 0
000093 15/07/2006 193 176 0 17
005715 14/07/2006 222 222 0 0
008957 16/07/2006 300 300 0 0
Required Format Code 7154 7155 7156 7157
Emp No Date Code Charge Rent Service Furniture
005083 14/07/2006 7154 88
005083 14/07/2006 7155 71
005083 14/07/2006 7156 0
005083 14/07/2006 7157 17
000086 16/07/2006 7154 107
000086 16/07/2006 7155 107
000086 16/07/2006 7156 0
000086 16/07/2006 7157 0
000093 15/07/2006 7154 193
000093 15/07/2006 7155 176
000093 15/07/2006 7156 0
000093 15/07/2006 7157 17
Thanks
Mike
|