| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
advanced paste special transpose
I have some data in the following format:
TTL VAL A 1 A 2 A 3 B 1 B 2 B 3 C 1 C 2 C 3 and i want it into this format... A 123 B 123 C 123 any suggestions. the only reason this is so difficult is becasue i need to do it a formula as i have over 300 000 records over 4 different excel worksheets. Thnx -Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste special transpose problem | Excel Discussion (Misc queries) | |||
| Transpose, Paste Special | Excel Discussion (Misc queries) | |||
| Paste Special / transpose | Excel Discussion (Misc queries) | |||
| When I special paste and transpose.... | New Users to Excel | |||
| Paste Special - Values - Transpose | Excel Worksheet Functions | |||
Threaded Mode
