Forum Discussion
Helper ICreate multiple colums from text values in one colum
Hello,
I have a table with articles, the problem is that i have one colum(kenmerk2) filled with header names, this headers should be seperate coulms.
| Article | value | Headername |
| 123456 | 125 | Sales Price |
| 123456 | 100 | Buying price |
| 123456 | 250 | Buying quantity |
Is should be something like this, then i can use the colums in my dashboard for the sum of Sales Price or Quantity.
| Article | Sales Price | Buying price | Buying quantity |
| 123456 | 125 | 100 | 250 |
Does anyone have a good idea for this?
Regards Björn
Hello Pattem,
This works for 90%, now the grouping increase my dates till only one date, but I want to keep the dates so that I can see my what happens monthly. So that the values per month are in one row, like the table below.
Article Sales Price Buying price Buying quantity Date 123456 125 100 250 1-1-2018 123456 50 25 10 2-1-2018 123456 200 100 25 3-1-2018 123456 125 100 250 4-1-2018 123456 125 100 250 5-1-2018 123456 125 100 250 6-1-2018 Regards Björn
7 Replies
- LivioLanzo
Solution Sage
bkoenenHi Livio,
That works fine, thank you.
Now the next question is, can I put the rows together with the same article number and same date, then I have one row with the colums filed with the values.
Now I have this
Article Sales Price Buying price Buying quantity Date 123456 125 null null 1-1-2018 123456 null 100 null 1-1-2018 123456 null null 250 1-1-2018 and I would like to have this,
Article Sales Price Buying price Buying quantity Date 123456 125 100 250 1-1-2018 regards Björn
- PattemManohar
Community Champion
