Forum Discussion
Updating equipment locations
Hello! I'm trying to create a equipment tracker that lists field numbers for equipment under columns labeled as specific locations. Each column has a name such as D1, D2 etc.. On a separate she...
TripL1337 I believe you can achieve this by pivoting the data based on the TO column. The attached workbook contains four examples.
The first is a regular pivot table that marks each field in the correct column with the number one as regular pivot tables can't hold texts in the value field.
The second option is to use Power Pivot, using a DAX measure that will allow to put texts into the value field.
The third example is done by Power Query and the last one uses dynamic arrays formulae.
Hopefully, you'll find one of these useful.