Forum Discussion
Table.Pivot - Pivoted Column - dealing with duplicates
I'm exporting data out of a jotform. The form is for daily inventory counts. The counts are coming in specitic to warehouse Location and Bin (a location can have multiple bins). For example, item aa...
At step4) - "4) generalize the [Attribute] column into values containing either "Location" or "Count".",
if you split the column from non-digit to digit and leave both columns in place, you can do the Pivot with "Don't aggregate". There shouldn't be any errors at that point.
You can then sort out the datatypes, maybe remove columns and probably do a 'Group By' to get what you want
1) That's a yes. You get 2 columns Location/Count/Bin in one and values from 1-3 in the sample data
2) Yes.
--
What do you have after doing that?
Ok never mind, I was able to figure it out. I needed to Group By that Digit column, that was confusing me. But I got it to work now based on your response. Thanks for helping!