@Ajitesh wrote: Hi Everyone,   I am facing issue in data manipulation. Please help. I have input file as Input File ID      Date         Flag1 ABC 24-Oct-21 23 ABC 23-Oct-21 45 ABC 8-Oct-21   33 XYZ 24-Jul-21   44 XYZ 25-Jul-21 98   Output require- ID      Date       Flag1    Date2  Flag2  Date3  Flag3 ABC 24-Oct-21 23      23-Oct-21 45     8-Oct-21     33 XYZ 24-Jul-21 44       25-Jul-21   98 Why do you need to do this? What analysis will you be performing on this data? Most times, analyses are easier performed on long data sets which you have, rather than wide data sets. ... View more

This sounds like an XY problem. http://xyproblem.info/   Please explain what you are trying to do (the larger picture). Explain in more detail what do you want this macro to do? How does being able to do that help with the larger problem? ... View more

Thank you so much. ... View more