| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can excel pivot text?
Is there anyway of pivoting text. I have 2 columns, a sample of which is
below: Column 1 Column 2 ACID SHOP ETCH1 ACID SHOP ETCH3 ACID SHOP ETCH4 HAND FORGE HF31 HAND FORGE HF32 HAND FORGE HF5 14 PRESS 14PE 14 PRESS 14P 8 PRESS 8PH 8 PRESS 8PP AREA 9 DRESSCO AREA 9 DRESSTI AREA 9 DRESSEN From this I am wanting to have the following results: Column 1 Column 2 Column 3 and so on ACID SHOP HAND FORGE 14 PRESS ETCH 1 HF31 14PE ETCH 3 HF32 14P ETCH 4 HF5 This is easy for numbers using pivot table but would like to use the same princaple but for text? the spreadsheet is very large and I dont want to do it manually. The spreadshet is exported from Access, so if the is an easly way in access please let me know. Regards Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) | |||
| get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
| setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
| Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
