Forum Discussion
Create groups of columns
My table has the following collumns Stock Total - E1 - N0 - Product 1 Stock Total - E1 - N1 - Product 2 Stock Total - E1 - N2 - Product 3 Stock Total - E2 - N0 - Product 1 Stock Total - E...
Well I ended up rebuilding my excel file and divided it in various tables. Thanks anyway
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
How about unpivoting them into rows? For example, one column is "Date". All the rows will be dates. If we want to sum up by month, we only need to add a condition "month([Date]) = 1". While if the dates are in columns, we have to do it like this: [column1] + [column2] + ... ... + [column31].
Best Regards!
Dale
Well I ended up rebuilding my excel file and divided it in various tables. Thanks anyway