Forum Discussion
Helper IICreate a new column from one value in an existing column (pivot)
Hi,
Is there a way to pivot just one value in a column? E.g. from the below dataset I'd like to create a new column from Order Number where each unique response_id has the corresponding order number populated against it (expected behaviour would be the same value duplicated across many rows, which is fine).
Thanks, Adam
no you cant pivot by only a unique value, now you can do the normal pivot of the whole column, select the resulting column you want and use remove others columns fucntion so only will be left the one of the value you wnated.
if this solved your question please give some kudos and mark as solutions for others to find.
1 Reply
- StefanoGrimaldi
Resident Rockstar
no you cant pivot by only a unique value, now you can do the normal pivot of the whole column, select the resulting column you want and use remove others columns fucntion so only will be left the one of the value you wnated.
if this solved your question please give some kudos and mark as solutions for others to find.