I have a rather simple table where column A contains a Category and Column B
contains a value. I would like this rearranged to where the Categories in
column A are shown as column headers and the values in column B are simply
listed under their category (No counting, summing, etc). Using the pivot
table I can get the column headings correct but have been unable to simply
list the values under the appropriate heading.
Can someone please provide me some guidance.
Thanks
Chas

Chas,
Without seeing your data it's hard to know if this is exactly what you want,
but this may work. Create a new sheet, and copy your table from the first
sheet. On the new blank sheet select the cell in the leftmost uppermost
corner, and hit the dropdown arrow on the Paste button (lefthand side of the
toolbar). On that dropdown menu select Transpose, which should transform
your data into the form you want.
Regards

"Chas in Colorado" wrote:

I have a rather simple table where column A contains a Category and Column B
contains a value. I would like this rearranged to where the Categories in
column A are shown as column headers and the values in column B are simply
listed under their category (No counting, summing, etc). Using the pivot
table I can get the column headings correct but have been unable to simply
list the values under the appropriate heading.
Can someone please provide me some guidance.
Thanks
Chas

Thanks for the info, The solution is close but not exactly what I'm looking
for.
Assume cells A1 through A4 all contain the label "Item 1" and cells A5
through A8 contain "Item 2". Now in B1 through B4 number these R1, R2, R3,
R4. in B5 through B8 enter R5, R6, R7, R8. I'm looking at something to
transform this to where Cell A1 would contain the Label "Item 1" and have R1
in A2, R2, in A3, etc. Then in cell B1 would be the literal "Item 2" and B2
would be R5, and R6, R7, and R8 on down.

"Jbm" wrote:

Chas,
Without seeing your data it's hard to know if this is exactly what you want,
but this may work. Create a new sheet, and copy your table from the first
sheet. On the new blank sheet select the cell in the leftmost uppermost
corner, and hit the dropdown arrow on the Paste button (lefthand side of the
toolbar). On that dropdown menu select Transpose, which should transform
your data into the form you want.
Regards

"Chas in Colorado" wrote:

I have a rather simple table where column A contains a Category and Column B
contains a value. I would like this rearranged to where the Categories in
column A are shown as column headers and the values in column B are simply
listed under their category (No counting, summing, etc). Using the pivot
table I can get the column headings correct but have been unable to simply
list the values under the appropriate heading.
Can someone please provide me some guidance.
Thanks
Chas