Hello,
If I a spreadsheet with a list of years in one column, and I want to mirror the rows but instead of the year being reflected, I want to add months for each year. So if I have
2022
2023
2024
2025
I need it to have
2022 Jan
2022 Feb
2022 Mar
2023 jan
2023 feb
2023 mar
etc...
I cant seem to figure out a robust way to add the months to each year in my data.
@Destinitruth one way of doing this with the help of generate row tool
Thank you so much ! 100% solved my issue!
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |