I have the an excel sheet with the some data in the following format:
metricDetails Identifier effectiveTime recordTime Details
MetricValue 207610 10:21:28 PM 23/04/2022 0.02622
MetricDays 207610 10:21:28 AM 23/04/2022 114
MetricValue 207271 10:21:28 PM 23/04/2022 0.004375
MetricDays 207271 10:21:28 AM 23/04/2022 30
Being a novice excel user, I would need to some help to get a formula that i can use to transform the data to the below format : essentially the metric value and metric days data should get populated in a a single row and two separate columns ( Metric A, Metric B)
Output
Identifier effectiveTime recordTime MetricA MetricB
207610 10:21:28 PM 23/04/2022 0.02622 114
207271 1:21:28 AM 23/04/2022 0.004375 30
Bookmarks