Oct 19 2021 07:29 AM
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 under one person ID but in separate rows containing that person's id number in the first column. see attached file. Help would be appreciated
Oct 19 2021 08:18 AM
Oct 19 2021 08:27 AM
Oct 19 2021 09:10 AM
Oct 19 2021 09:50 AM
Oct 19 2021 10:28 AM
Solution@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
Oct 19 2021 10:39 AM
Oct 19 2021 10:28 AM
Solution@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