Hi -
I've exported data from another program and done text to columns, now i just need the data to be in the correct headed columns. I've thought about using match/index as the data isn't in a consistent order, but i'm getting nowhere fast. I'd like a separate sheet with the column headings the same as the entries, ie. BYODC, LFD, VIS, WCH, etc. and the room code (left-most column shown below) as the row labels.
<tbody>
</tbody>
Thanks very much
I've exported data from another program and done text to columns, now i just need the data to be in the correct headed columns. I've thought about using match/index as the data isn't in a consistent order, but i'm getting nowhere fast. I'd like a separate sheet with the column headings the same as the entries, ie. BYODC, LFD, VIS, WCH, etc. and the room code (left-most column shown below) as the row labels.
ARK109 | 1 x BYODC | 1 x LFD | 1 x VIS | 1 x WCH | 1 x PC | 2 x WGB | 1 x DVD | 1 x LEC | 1 x SYM | ||||||||
ARK110 | 1 x BYODC | 1 x LFD | 1 x VIS | 1 x WCH | 1 x PC | 2 x WGB | 1 x DVD | 1 x LEC | 1 x SYM | ||||||||
ARK111AREA1 | 1 x BYODV | 1 x VIS | 1 x VRRM | 1 x WCH | 1 x PC | 1 x DP | 1 x VRARM | 1 x VRFM | 1 x LEC | 1 x LCF | 1 x SYM | 1 x BYODH | 1 x BYODW | 1 x DVD | 1 x PRJ | 1 x SPKR | |
ARK111AREA2 | 1 x WCH | ||||||||||||||||
ARK112 | 1 x BYODC | 1 x VIS | 1 x NET | 1 x WCH | 1 x BYODW | 1 x PC | 1 x DP | 1 x DVD | 1 x LEC | 1 x SPKR | |||||||
ARK115 | 1 x BYODV | 1 x VIS | 1 x NET | 1 x VRRM | 1 x WCH | 1 x PC | 1 x DP | 1 x VRARM | 1 x VRFM | 1 x DVD | 1 x FIXT | 1 x BLA | 1 x IL | 1 x LCF | 1 x LEC | 1 x SYM |
<tbody>
</tbody>
Thanks very much