M
mbrossar
Is it possible to pivot text data in Excel?
I have a spreadsheet with 3 columns of text data. Moving from left t
right (i.e. Column A to column C), the data is broken down into mor
granular detail. For example:
A. Column A contains the host name of a PC. The host name is repeate
in each row that applies to that host.
B. Column B are the titles of the data. i.e. Memory, HD Size, # o
processors, etc. The titles repeat as necessary for each of the hos
names in column A
C. Column C is the data itself. It is text, not numeric
I'm trying to pivot the data such that:
1. Each host name (from column A) occupies only one row.
2. The titles of the data (from column B) are pivoted to the colum
headings. One column per unique data title. No repeated data titles.
3. The data (from column C) is spread appropriately in the pivote
worksheet.
A standard pivot table gets me very close, but it only deals wit
numeric data
I have a spreadsheet with 3 columns of text data. Moving from left t
right (i.e. Column A to column C), the data is broken down into mor
granular detail. For example:
A. Column A contains the host name of a PC. The host name is repeate
in each row that applies to that host.
B. Column B are the titles of the data. i.e. Memory, HD Size, # o
processors, etc. The titles repeat as necessary for each of the hos
names in column A
C. Column C is the data itself. It is text, not numeric
I'm trying to pivot the data such that:
1. Each host name (from column A) occupies only one row.
2. The titles of the data (from column B) are pivoted to the colum
headings. One column per unique data title. No repeated data titles.
3. The data (from column C) is spread appropriately in the pivote
worksheet.
A standard pivot table gets me very close, but it only deals wit
numeric data