Ok - So you have a cash book for an account and each row has a relevant income/expense type in the 'category' column.
When you then filter this column, there are around 30 different types. If I then wanted to amend the way the spreadsheet works and show the categories along the top with each having it's own column rather than there being only one column for the amounts, is there a quick way of only populating the unique category labels along the top row rather than manually entering? I have subtotalled the sheet and went down copying one 'name' from each category and then pasting along the top by transposing. In the above example, there are only thirty but it could have been worse.
Also, if you then wanted the spreadsheet to show the value in the appropriate cell (i.e., in the new category column) with reference to the original category column (matching against the the category name above the value cell) is this possible? It sounds like it is with some kind of matching/Lookup formula, but can't fathom it out!!
Could you not just create a pivot table from it with the row labels across the top?
Your raw data may need hacking about a bit to get it in the right format to extract from.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I realise that I could have used a pivot table......but it is the raw data that I am trying to re-format. I want everything to be seen as it is on the page, but have a columnar total for each category and so want to do this just once.
I thought that there would be a way to select just the unique entries in a field (of which there may be hundreds) and quickly paste them as a list.....or in this case transpose along the top row to create column headings. I still think this MUST be possible in something as sophisticated as Excel????!
Do not omit the {} on either end as that bits important.
Now drag that down to the last line as you did with column H.
Ta dah... A list of the unique occurences in column C delimited by the count from row I and appearing on consecutive rows.
Was that what you were looking for?
As the last step for what you want just copy and paste special to another worksheet. You want to paste special as you are posting the values, not the formulae plus on the paste you need to tick the transpose button... Wallah. All your uniques in one column each.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
