Forum Discussion
Index Match for querying salary data over time
I have a dataset with the columns shown below: As you can see in the sample of the data posted above, some employees have had three or four pay changes (employee #6) while others have...
Assuming [Pay rate change month] column contains Text values and not real dates formatted as mmmyy, with Power Query then Pivot Table (sample attached)
If [Pay rate change month] column contains real dates formatted as mmmyy a classic Pivot Table will do what you want in a minute (also in attached file)