Hello!
I have an excel, where there are EID’s of users and Asset Tags - AT -Saving the data in Datatable.
And it looks like this:
EID AssetTag
EID1 AT1
EID2 AT2
EID3 At4
EID1 At8
EID4 AT9
EID1 AT10
As a result i want to have something like
EID AssetTag1 AsseTag2 AssetTag3 …
EID1 AT1 At8 AT10
EID2 At2
EID3 At4
EID4 At9
I was thinking about some for each row function, then finding with lookup datatable the eid and put the results in some table ( if its possible), and then put that values one by one to the next columns. But i cannot implement that. Do you have any idea how to solve this problem?