A UNION query can rearrange data.
But I agree with others. If you are developing db, then normalize.
If this is provided data for which structure you have no control over and must deal with, use UNION. There is no wizard/designer for UNION, must type or copy/paste in SQLView of query builder.
SELECT [Name], age, category, module1 AS Data, "M1" AS Src FROM tablename
UNION SELECT [Name], age, category, module2, "M2" FROM tablename
UNION SELECT [Name], age, category, module3, "M3" FROM tablename;
Name is a reserved word and should not use reserved words as names for anything.