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:
As a result i want to have something like
EID AssetTag1 AsseTag2 AssetTag3 …
EID1 AT1 At8 AT10
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?