Forum Discussion

Copper Contributor

Oct 19, 2021

Solved

Decoupling rows

I have a file with unique person ID's in the first column and different products that they have purchased in another column. I want to change the product descriptions so that they are not bucketed un...

Decoupling rows.xlsx10 KB

excel

bosinander
Oct 19, 2021
Rosanna985 Hi. It seems you have a static pivot table that you want to use as a merely normal data range? The empty cells have to be filled with the data/Person ID above..?

eg L6 shows A6 but J7 has to show J6 since A6 is empty?

J5 =IF(A5="",J4,A5)
Copy the to J5:N20
The value columns are not to be repeated and thus just fetching data in o5:Q20.
o5 =F5
If you want to get rid of the Total rows, there is an applied filter in S5

IF Decoupling rows.xlsx25 KB

Rosanna985

Copper Contributor

Oct 19, 2021

thanks for the additional response. This does not yield the desired outcome but I do thank you for responding

bosinander

Iron Contributor

Oct 19, 2021

Rosanna985 Hi. It seems you have a static pivot table that you want to use as a merely normal data range? The empty cells have to be filled with the data/Person ID above..?

eg L6 shows A6 but J7 has to show J6 since A6 is empty?

J5 =IF(A5="",J4,A5)

Copy the to J5:N20

The value columns are not to be repeated and thus just fetching data in o5:Q20.

o5 =F5

If you want to get rid of the Total rows, there is an applied filter in S5

IF Decoupling rows.xlsx25 KB

Rosanna985
Copper Contributor
Oct 19, 2021
hi bosinander. The output is EXACTLY what I was looking for. Thank you for laying out the steps you took to get there. Extremely helpful. Did not know the data was a static pivot table. Many thanks
- bosinander
  Iron Contributor
  Oct 19, 2021
  🙂 You're welcome.