topic ods html make columns rows (swap) in ODS and Base Reporting

ods html make columns rows (swap)

pe243 — Wed, 21 Feb 2018 16:59:38 GMT

hi everyone, an amateur here 🙂

..trying to find a way to have columns & rows swap their places.

You know, like you have one long row with many columns and you'd rather have it vertically, so row goes down as a column.

Is something like this possible, for html but no only?

many thanks, L.

GinaRepole — Wed, 21 Feb 2018 17:17:22 GMT

It sounds like you're trying to do a transpose. Check out PROC TRANSPOSE here and see if that might be able to do what you want.

Reeza — Wed, 21 Feb 2018 17:20:20 GMT

It's not clear how ODS HTML and your table structure are related.

It depends on your data and what you're doing but transposing data is usually a trivial task.