Table of data to format out

[help4]

Hi Guys and Gals, new here so go easy on me. I'm an sql monkey really but am stuck with doing something with that output in a spreadsheet.

My data is a plain table with a dynamic number of columns from my sql data source. I need to take this and return it into a seperate sheet so I can format it, I need to group it by my week commencing date already in the data set, then return however many rows belonging to it.

Help please

[Pete_UK]

It would help if you attached a sample workbook, showing before and after sheets - the FAQ describes how to attach a file to one of your posts.

Pete

[help4]

I've just attached a sample. The view sheet shows what I want, the InputData shows how it arrives.

Thanks

[oeldere]

with a pivot table, see the attached file.

[help4]

I did look at pivots however my table is around 30 columns wide and I don't want to go down the route of lots of + - symbols etc and want quite a clean output. Do you think this is possible?

[oeldere]

What do you mean with a lean output?

I don't want to go down the route of lots of + - symbols?

What information is in the other 30 columns (since they are not in the added example)?

[help4]

What do you mean with a lean output?

I don't want to go down the route of lots of + - symbols?

What information is in the other 30 columns (since they are not in the added example)?

Hi clean, just not full of + -
The other columns are all just text data and some aggregated in the data set already

[oeldere]

Hi clean, just not full of + -

Where do you see the +- in the pivot table?

You also did not tell us what you want to do with the information in the other columns.