How can I take advantage of sorting, filtering and generating charts from my data using "Format as table" option in Excel 2016 without losing its current table format?
Please note that when I convert my data using Excel automatic table formatting it loses its shape and I can no longer merge the cells.
My original data
My table after formatted
Kindly please help me because I need to report this data asap.