Right now Date is displayed in Row , needs to convert into column dynamically. Sample input data and expected output file is attached. Input data is located in Input tab and expected result is located in Output tab of attached file.
@irfanchoudhry I've come up with this solution to achieve what you are looking to do. When pulling data in directly from Excel, merged cells can be a pain. I've handled them based on the source file you provided, but additional tweaking might be needed to handle all cases from the input file. Hopefully this gets you started though.
User | Count |
---|---|
53 | |
27 | |
26 | |
24 | |
21 |